package com.lagou.study.mapper;

import com.lagou.study.pojo.LagouAuthCode;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;
import org.springframework.stereotype.Repository;

@Repository
public interface CodeMapper extends JpaRepository<LagouAuthCode, Integer>{
    @Query(value = "select * from lagou_auth_code where email = ?1 order by createtime desc limit 1", nativeQuery = true)
    LagouAuthCode selectCodeByEmail(String email);
}
